CREATE TABLE [dbo].[wap_numauto]
(
[cd_talonario] [dbo].[_codigo] NOT NULL,
[nm_talonario] [dbo].[_nombre] NOT NULL,
[tp_talonario] [dbo].[_lista] NOT NULL,
[va_prefijo] [char] (2) COLLATE Modern_Spanish_CS_AS NULL,
[va_numero] [dbo].[_entero] NOT NULL,
[st_bloqueado] [dbo].[_logico] NOT NULL,
[st_interno_sistema] [dbo].[_logico] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wap_numauto] WITH NOCHECK ADD CONSTRAINT [CK_wap_numauto] CHECK (([va_numero] >= 0))
GO
ALTER TABLE [dbo].[wap_numauto] ADD CONSTRAINT [PK_wap_numauto] PRIMARY KEY NONCLUSTERED  ([cd_talonario]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wap_numauto] ADD CONSTRAINT [IX_wap_numauto] UNIQUE NONCLUSTERED  ([nm_talonario]) ON [PRIMARY]
GO
EXEC sp_bindefault N'[dbo].[cero]', N'[dbo].[wap_numauto].[va_prefijo]'
GO
EXEC sp_bindefault N'[dbo].[cero]', N'[dbo].[wap_numauto].[va_numero]'
GO
EXEC sp_bindefault N'[dbo].[cero]', N'[dbo].[wap_numauto].[st_bloqueado]'
GO
EXEC sp_bindefault N'[dbo].[cero]', N'[dbo].[wap_numauto].[st_interno_sistema]'
GO
